UniDAC

TUniConnection Members

TUniConnection class overview.

Properties

Name Description

AutoCommit

Used to permit or prevent permanent updates, insertions, and deletions of data against the database server.

ConnectDialog (inherited from TCustomDAConnection)

Allows to link a TCustomConnectDialog component.

ConnectString (inherited from TCustomDAConnection)

Used to specify the connection information, such as: UserName, Password, Server, etc.

ConvertEOL (inherited from TCustomDAConnection)

Allows customizing line breaks in string fields and parameters.

Database

Used to specify the database name that is a default source of data for SQL queries once a connection is established.

DefaultTransaction

Used to access default database connection transaction.

InTransaction (inherited from TCustomDAConnection)

Indicates whether the transaction is active.

LoginPrompt (inherited from TCustomDAConnection)

Specifies whether a login dialog appears immediately before opening a new connection.

Macros

Holds a collection of macros that can be used in Unified SQL statements.

Options (inherited from TCustomDAConnection)

Specifies the connection behavior.

Password (inherited from TCustomDAConnection)

Serves to supply a password for login.

Pooling (inherited from TCustomDAConnection)

Enables or disables using connection pool.

PoolingOptions (inherited from TCustomDAConnection)

Specifies the behaviour of connection pool.

Port

Used to specify the port number for TCP/IP connection.

ProviderName

Used to switch the current data access provider.

Server (inherited from TCustomDAConnection)

Serves to supply the server name for login.

SpecificOptions

Used to provide extended settings for each data provider.

Username (inherited from TCustomDAConnection)

Used to supply a user name for login.

Methods

Name Description

ActiveMacroValueByName

Returns the value of the specified macro for the current provider.

ApplyUpdates (inherited from TCustomDAConnection)

Overloaded. Applies changes in datasets.

AssignConnect

Shares database connection between the TUniConnection components.

Commit (inherited from TCustomDAConnection)

Commits current transaction.

CommitRetaining

Permanently stores all changes of data associated with the default database transaction to the database and then retains the transaction context.

Connect (inherited from TCustomDAConnection)

Establishes a connection to the server.

CreateDataSet

Creates an instance of the TCustomUniDataSet class and assigns its TCustomDADataSet.Connection property.

CreateSQL

Creates an instance of the TUniSQL class and assigns its TUniSQL.Connection property.

CreateTransaction

Creates an instance of the TUniTransaction class and adds itself to its TUniTransaction.Connections.

Disconnect (inherited from TCustomDAConnection)

Performs disconnect.

ExecProc (inherited from TCustomDAConnection)

Allows to execute stored procedure or function providing its name and parameters.

ExecProcEx (inherited from TCustomDAConnection)

Allows to execute a stored procedure or function.

ExecSQL (inherited from TCustomDAConnection)

Executes a SQL statement with parameters.

ExecSQLEx (inherited from TCustomDAConnection)

Executes any SQL statement outside the TQuery or TSQL components.

GetDatabaseNames (inherited from TCustomDAConnection)

Returns a database list from the server.

GetKeyFieldNames (inherited from TCustomDAConnection)

Provides a list of available key field names.

GetStoredProcNames (inherited from TCustomDAConnection)

Returns a list of stored procedures from the server.

GetTableNames (inherited from TCustomDAConnection)

Provides a list of available tables names.

MonitorMessage (inherited from TCustomDAConnection)

Sends a specified message through the TCustomDASQLMonitor component.

ParamByName

Provides access to output parameters and their values after executing an SQL statement with the TCustomDAConnection.ExecSQL method.

PerformConnect (inherited from TCustomDAConnection)

Establishes a connection to the server regardless of the LoginPrompt property.

Ping (inherited from TCustomDAConnection)

Used to check state of connection to the server.

ReleaseSavepoint

Destroys the specified savepoint without affecting any work that has been performed after its creation.

RemoveFromPool (inherited from TCustomDAConnection)

Marks the connection that should not be returned to the pool after disconnect.

Rollback (inherited from TCustomDAConnection)

Discards all current data changes and ends transaction.

RollbackRetaining

Used to roll back all changes of data associated with the transaction and retain the transaction context.

RollbackToSavepoint

Cancels all updates for the current transaction.

Savepoint

Defines a point in the transaction to which you can later roll back.

StartTransaction

Overloaded. Starts a new transaction at the server.

Events

Name Description

OnConnectionLost (inherited from TCustomDAConnection)

This event occurs when connection was lost.

OnError (inherited from TCustomDAConnection)

This event occurs when an error has arisen in the connection.
© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback